SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 425434 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 425434 [ RunTime:0.002067s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (8301,561251,864404,982895,469830,662000,1011808,140404,596621,396579,638971,912393,455331,24286,179366,517743,829753,4537,60286,532720,923901,497093,205816,650846,813561,142714,489,20427,686229,1023640,904802,953222,120206,27764,311463,618208,65539,8068,524393,252431,744108,371914,313199,561241,702397,842753,297479,674275,19222,908805,903840,305587,558512,1247,185668,764521,1037010,46268,22362,780497) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 425434 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 425434 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]