SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 900912 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 900912 [ RunTime:0.002019s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (442107,972221,122610,524225,1249,324713,1039146,810610,971043,904289,626641,191485,150824,420385,651670,108247,421842,449757,34972,352537,516167,504979,686437,688806,205502,38961,578831,683451,127981,974720,322128,1021634,155520,1016310,600295,426283,811499,700496,947305,164217,1028531,684420,679905,759023,628159,1017550,871377,755696,688159,154208,238034,283072,722256,597437,718564,586803,167284,65108,921637,554713) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 900912 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001791s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 900912 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]