SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002311s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 453974 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 453974 [ RunTime:0.003270s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (519000,1018048,31483,767000,7801,389511,323637,97902,515737,972504,1021128,314950,908956,667396,135413,540280,601779,236370,625349,149783,612900,874909,85497,408187,753322,207585,141087,436758,331030,882472,221823,1020409,627880,793756,76388,640366,191655,129016,113559,716987,201218,422912,7290,70951,349558,845271,916774,140280,183057,732045,3302,539390,556232,755137,228283,731739,638672,231777,64484,63957) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004683s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 453974 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000472s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 453974 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001305s ]