SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104071 LIMIT 1 [ RunTime:0.000486s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104071 [ RunTime:0.001946s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (153715,94944,404937,4282,556609,425900,560963,1021722,142471,416538,605407,474197,736932,41999,707726,550114,971457,896483,959164,664551,376016,675360,159724,858919,181374,972305,24906,839188,744617,542362,491798,815764,912219,611044,609275,317863,611850,811224,13648,221646,532772,502595,771972,723966,474554,193563,207192,394847,783417,639663,279801,255661,453979,155127,49217,313949,274868,983157,620840,653274) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001786s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104071 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104071 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]