SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001336s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516312 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516312 [ RunTime:0.002313s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (557598,975738,557392,848965,734223,542143,12023,496440,794399,817723,867497,719092,994846,892185,153048,362342,774516,403062,190391,833595,1013733,317590,450626,183566,7044,285461,388436,592469,3164,364333,109764,538028,393431,516703,100500,1046720,1002455,1025479,933903,808915,780865,560680,774647,496274,901316,459597,288211,554421,140556,407498,759960,171232,10191,797967,356093,783054,848443,575711,102082,791896) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516312 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516312 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]