SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 142128 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 142128 [ RunTime:0.003110s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (354218,411370,651879,314327,189383,462842,354873,817651,498989,470336,991111,913461,446477,42748,52004,488832,52540,596898,845951,292444,961426,762850,425246,39230,975776,1043394,265118,559122,625095,639501,149617,673291,900086,1038975,35345,15151,118169,885562,189263,477413,907090,903365,700473,80553,76489,915891,372409,256662,340093,61835,986898,197021,1028945,537358,499842,388885,441588,418013,167399,698793) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 142128 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 142128 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000661s ]