SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028913 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028913 [ RunTime:0.001603s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (164683,809623,192106,611299,957743,123412,785915,1048490,1016640,692980,163390,227655,619538,938534,190960,320248,1027183,312485,835828,549610,157976,162089,866488,958509,667451,947994,663011,219501,590207,807867,563952,376647,802080,445895,713073,920945,235962,871879,876822,847892,384412,1044155,285175,507545,510678,422304,1022979,994100,215164,6215,572936,326025,722854,108141,128420,32183,389549,657075,173399,142932) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000984s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028913 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028913 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000823s ]