SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001321s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 55640 LIMIT 1 [ RunTime:0.002580s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 55640 [ RunTime:0.001961s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (60391,272819,24184,744349,179836,756150,277373,910035,998975,350755,649678,591326,144369,21673,211485,14435,341456,590723,142095,732909,770803,771267,505266,12717,540588,858208,15236,445181,592398,314384,618208,875842,908332,894023,265509,840111,466250,796715,595873,10118,112953,82338,315608,27377,271214,436692,424153,37000,857677,897790,19997,607535,637703,223172,62174,36359,976075,323527,23006,800116) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 55640 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000617s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 55640 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000380s ]