SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031902 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031902 [ RunTime:0.001712s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (535147,330692,521207,685412,775767,815109,333240,905581,1030906,240206,1048349,279332,401690,721026,149753,68919,529595,827130,365906,366458,311093,1025744,541818,832791,349543,122526,723994,506925,317497,790264,705812,1021053,65324,921159,662394,1020223,997369,728289,976385,269446,274942,571902,377153,539622,71767,466281,846695,955950,194876,856767,671660,482007,132878,559364,101708,504852,959681,526728,160748,36374) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031902 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031902 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]