SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 358812 LIMIT 1 [ RunTime:0.001279s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 358812 [ RunTime:0.002115s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (887073,760970,756587,273317,768528,38345,257544,34486,229762,979268,375166,140052,224740,178902,451161,27735,612801,505605,1048680,370432,129605,315548,395577,948250,1013926,694518,662248,320939,719280,179884,665290,422933,303076,505776,231392,797719,788348,462460,529331,997287,1033928,568925,1034901,753519,786046,7211,341940,449871,279057,678395,984996,410662,461657,983756,909152,338463,958295,233947,296192,686416) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002810s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 358812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 358812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]