SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412576 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412576 [ RunTime:0.001530s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (404599,802477,589340,887967,186384,550911,687055,985738,202714,777659,867104,968738,152706,997936,604924,86696,977751,602065,313278,262465,643189,932730,861637,767175,346636,623600,970902,597735,651073,635711,847544,244843,656462,228436,723305,730947,555764,846020,780930,120988,599245,568176,897229,703018,930816,978523,694408,773320,80636,684559,648726,637714,355944,817787,501015,460120,171788,1028759,314531,866622) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000951s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412576 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412576 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]