SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019995 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019995 [ RunTime:0.002474s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (978603,460902,764626,284472,588256,582377,499154,444852,736016,314532,819311,70892,98090,860880,77453,571364,264438,109424,776937,1022494,750282,799605,110147,413769,399839,930076,165385,932002,880657,331152,850779,926353,995884,881082,95564,676201,626959,35766,820372,64724,189738,92739,561152,1033174,523797,89152,59666,213873,21815,880976,883663,821789,3944,818255,821312,831036,824990,453727,31271,255024) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019995 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019995 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000752s ]