SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1021344 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1021344 [ RunTime:0.002768s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (305740,313886,730524,730881,804999,913880,102336,68709,943566,264905,33512,865037,381312,505025,713233,960273,1046889,587133,499912,177408,69181,1000449,867184,217691,4516,260979,170562,392810,435395,991983,614642,441872,795387,19405,531847,96095,657833,754836,803269,1016247,295706,92349,448331,187978,1800,368586,189555,200191,977938,903644,488481,279525,533727,776322,873876,271005,271851,861487,788706,937935) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1021344 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1021344 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003370s ]