SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419505 LIMIT 1 [ RunTime:0.000694s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419505 [ RunTime:0.004049s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (263736,4618,253194,151594,992175,997838,805182,852615,335677,856394,69483,386872,837023,696726,997785,125926,24619,330513,117997,37706,166574,379702,520469,978331,1003662,84893,715615,423528,825966,332658,531509,999959,560319,976179,533170,839797,141577,48667,379519,595536,467361,31455,860783,7541,822231,657648,380492,476550,194313,642985,742427,1034836,1047390,237833,561508,736018,272264,386739,291366,480778) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001581s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419505 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419505 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]