SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410315 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410315 [ RunTime:0.001588s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (180247,794214,651395,268860,238334,852120,98964,301044,883516,999709,967901,530882,790551,677852,308853,133553,992143,212847,439453,695714,898641,956447,302165,217400,701662,425931,653853,608537,716972,719834,383308,249474,288490,669541,885987,443097,898676,474017,1021309,448509,957130,155689,109674,375222,182195,722932,767090,886704,919722,398858,208773,351534,593408,113046,416244,969006,654264,210260,488727,712406) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001890s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410315 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410315 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]