SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000951s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200391 LIMIT 1 [ RunTime:0.000823s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200391 [ RunTime:0.001935s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (572479,859720,154893,988814,1046529,364416,983785,117360,604680,127018,1027378,47825,111662,346676,534483,1002435,737943,192452,1030110,64535,343143,35783,992232,65689,1022292,269144,191609,983798,225092,1043210,550767,8709,669446,36662,985830,609903,683245,852704,670313,666790,696594,551909,922605,159707,79734,213500,431537,655583,118354,987886,945450,892797,423662,854041,654765,428754,811908,89171,776711,83335) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001855s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200391 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200391 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]