SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311740 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311740 [ RunTime:0.001967s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (409946,110419,512077,66510,1590,992161,424332,417143,415538,228257,878200,169467,173353,854376,651002,1026741,198129,908456,766604,100586,280355,676231,489634,597154,956737,556095,291783,538517,29550,146867,561032,302854,806096,376611,838594,466687,393564,106355,764094,476554,961493,332919,374380,921490,151531,979479,717425,208989,696203,683529,409349,863341,602946,593840,1004012,227389,542908,1031267,827347,997230) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311740 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311740 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]