SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 513829 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 513829 [ RunTime:0.001664s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1002141,28763,513029,826048,261170,644908,570342,286923,617558,40428,380349,62428,919460,824716,168520,378119,833801,499197,469805,1030446,994981,258456,79297,742385,797886,246174,178599,290317,42153,418161,221186,419979,160959,60389,505747,506472,891198,95257,549340,782198,898935,1017330,167235,354132,253997,152613,404600,822510,606028,1016412,720161,383617,844655,163747,476405,438149,562989,361932,1009065,335115) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 513829 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 513829 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001301s ]