SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042754 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042754 [ RunTime:0.001591s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (730075,282153,199479,420998,193913,239682,4980,603855,65863,114862,437819,1046924,1003356,420081,83752,12832,851489,725756,246707,922599,486051,691559,327743,78609,1040940,359969,467464,585436,141676,970880,624832,293157,773991,247514,601816,478544,541805,1012172,170193,851358,437880,341800,331362,422871,382153,807078,322429,498187,445103,597388,577338,782218,373343,470460,860976,40684,567955,741435,407550,489139) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.024139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042754 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000606s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042754 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002398s ]