SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 107857 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 107857 [ RunTime:0.001733s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (471627,402933,29295,115839,133090,150571,809167,363324,33214,299877,767177,863981,1007707,713993,421849,63849,741306,553142,193023,151050,988439,77124,652518,731853,399584,437692,350774,319952,801348,298004,226980,673435,722064,345789,850221,736134,209483,782551,765971,752359,901441,406948,344722,354118,109516,450378,120124,891043,106507,61816,136015,322593,308898,213688,892537,962567,148149,364199,829184,681736) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 107857 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 107857 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000686s ]