SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 344274 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 344274 [ RunTime:0.001617s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (514209,480791,396449,1039486,906749,535144,287392,567985,796002,846182,919987,193029,191600,29421,26442,857861,32227,746838,291707,991336,329846,285017,42395,237559,888880,266523,607493,191660,176889,958341,565447,814004,497738,587912,491235,678486,469186,29803,310624,674779,899295,763921,969879,215150,246176,125905,214214,231517,86531,943394,881547,747400,873294,1013799,280544,267631,455747,731349,462393,243699) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000982s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 344274 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000546s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 344274 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]