SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1025602 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1025602 [ RunTime:0.001580s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (652835,936340,897260,182746,916757,316228,69005,605002,893630,192559,161801,997181,966656,786783,220437,706423,364984,357880,234855,825764,878985,828511,767008,1025849,17927,255945,796543,37072,717397,952309,934225,213863,845429,1046767,309313,111473,318840,256247,852746,346258,64788,669543,107327,43992,622879,1007535,853206,110763,520406,657788,940102,985528,249740,987969,1011513,767520,602672,315106,76064,804693) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004098s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1025602 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1025602 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000468s ]