SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422701 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422701 [ RunTime:0.002249s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (558179,522935,181930,5073,729183,1045622,128827,508364,280014,99302,1038991,267679,26316,202396,1047250,384337,927355,831181,214669,932120,378324,1009050,1008525,869856,916129,604914,544430,520083,294743,456330,809682,179048,1008656,12328,41809,349403,721838,676076,277776,430433,237169,1011503,152988,777062,987538,896426,260626,676675,273035,279998,817907,600625,58063,475004,842846,148433,780984,880444,19888,263188) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422701 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422701 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]