SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481010 LIMIT 1 [ RunTime:0.000429s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481010 [ RunTime:0.002113s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (923052,483037,602556,498183,337330,727539,1037327,52830,572642,37242,374399,233676,721186,220112,979417,428576,462155,706338,984870,1008812,168517,846373,714057,162749,147384,968549,164948,648071,378781,371326,521810,63115,811664,896221,296782,303850,454424,66200,1001250,264375,687198,719292,850925,230673,59384,180572,985903,337922,216036,381079,108955,59448,176034,378820,955532,720294,226053,733515,134019,865020) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000767s ]