SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 482212 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 482212 [ RunTime:0.001912s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (428355,1026438,111834,401443,879025,98393,529851,434148,876022,715318,848499,661927,416170,309443,268971,542574,980088,895553,590351,294367,747983,653984,17423,206633,55150,645023,55127,315017,816868,634828,4178,631598,803016,533868,364865,778992,353732,485558,244076,998589,741235,565327,656417,128065,963760,543612,95899,236155,580430,966823,144721,190250,636780,100035,863248,780710,860424,769584,1010227,294473) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001474s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 482212 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 482212 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]