SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002368s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804543 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804543 [ RunTime:0.003089s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (677785,308170,193285,744089,546926,150213,456508,417057,626649,742703,469971,240097,305859,324846,247724,850491,129364,967383,151155,301829,255166,349420,995044,357280,616855,331776,560355,293374,229276,500462,141014,427219,957961,998693,141575,221428,98707,568784,551205,854383,550636,657969,541590,982859,705988,280184,123862,869599,638942,81780,863737,100472,560839,913871,912372,135118,843423,834205,669569,12521) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804543 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804543 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001525s ]