SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412905 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412905 [ RunTime:0.002433s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (943441,64075,763330,389289,77722,51606,768816,817862,159268,417221,133890,866773,553263,684553,766078,24407,848336,14903,823029,545983,824109,972173,708068,814871,394814,137776,636883,977080,190533,202513,288107,414015,668129,113654,724850,123515,809723,828104,689422,341145,805116,370487,93342,356106,98986,240917,704921,333248,635190,1033744,59601,740391,974856,399924,200590,882373,405600,768081,989555,209620) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412905 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000501s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412905 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]