SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 20316 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 20316 [ RunTime:0.001521s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (21189,1031991,305147,892048,396588,997247,1639,433620,834707,322460,174141,216977,917083,289369,959122,792663,833598,1018377,450352,242484,392981,881176,938059,959100,1026448,967825,628122,196620,643357,114165,966000,1031368,390888,64961,156227,147383,283318,405023,179785,480945,607375,919337,150014,915241,152885,520000,1011415,942211,975476,799069,548943,278438,579208,613875,947019,145290,326580,187519,168542,412183) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001319s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 20316 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 20316 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000398s ]