SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510831 LIMIT 1 [ RunTime:0.000467s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510831 [ RunTime:0.002047s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (473241,457762,281981,870756,850800,1004972,571929,281869,759904,766958,142863,411649,671887,182705,932001,717405,485992,299417,454680,591531,1042148,323581,890625,220692,700174,144053,600328,1045119,832983,1008529,523990,110502,991205,819437,272485,338319,60523,46765,383836,2630,131378,451311,7460,386747,450036,553910,44197,184924,669248,540122,225758,330828,757264,476772,56312,393696,404148,998538,859531,680666) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510831 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510831 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]