SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 35890 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 35890 [ RunTime:0.001617s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1002902,441952,145663,865666,357121,846969,755035,144850,887825,991842,210002,511875,1022154,805947,954442,1045326,33952,881772,308034,518300,631001,882611,643411,615629,1013236,976537,704842,331295,980255,79817,176782,951806,203650,411890,250160,72517,84742,399107,612621,477006,562645,563907,144570,373051,141863,326173,314688,465130,585617,909064,34979,24998,987854,740640,675074,538854,909081,902309,800325,104265) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001503s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 35890 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 35890 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000601s ]