SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514610 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514610 [ RunTime:0.002467s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (856275,242716,453736,62972,988635,518477,171620,224635,749066,821061,974985,234680,1040814,208328,122705,144936,327992,423805,671792,872630,923521,110428,218656,822114,127178,21801,718831,96831,258534,963650,577354,476005,981989,486803,64280,634396,202494,740017,970949,839958,596988,227649,896060,63053,557915,301822,404042,1020521,591240,913717,939597,989393,919488,120375,463209,123113,148108,870110,549578,219015) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]