SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519907 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519907 [ RunTime:0.001791s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (474568,820554,10636,657017,326725,48421,1046619,989259,767851,496389,284019,916622,156919,979163,345328,754520,71056,635872,881618,219214,671056,366800,792921,308703,1034844,530936,396590,624049,578321,34578,325790,146378,228046,890107,98960,891433,189790,821396,33134,506925,1001771,824742,717325,298340,336364,587502,662415,1024078,227940,450735,345618,617793,274071,29098,142226,1000559,14204,712113,695952,477366) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000924s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519907 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519907 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]