SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002812s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001243 LIMIT 1 [ RunTime:0.002154s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001243 [ RunTime:0.004967s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (950777,275706,778778,137349,264024,121812,493572,933739,267128,253424,833655,897274,618543,82601,73505,606614,1005413,915667,89005,54331,355528,739594,125659,510922,596361,482310,356434,233350,948423,957697,954091,851970,1016803,545266,80005,1028980,658624,664412,860354,408568,816576,830013,718433,946300,28561,932464,475273,579119,866815,654810,577292,347953,460713,95864,1004390,885928,266168,483708,66597,564962) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001749s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001243 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001548s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001243 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000687s ]