SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 981916 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 981916 [ RunTime:0.001844s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1014955,600450,554222,262173,292678,188673,633360,83959,964118,1020523,592466,175469,257984,69360,919110,974222,228182,623947,943210,717391,891849,587581,692786,34016,33577,867372,124773,135323,284579,43644,181705,1015849,155886,180372,1039956,14445,1021801,723565,727119,683024,857691,516027,224516,314890,485444,753990,117844,938601,418481,75036,609850,802939,877908,870766,90202,69137,261883,48252,479745,341682) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 981916 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 981916 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000674s ]