SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001356s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047714 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047714 [ RunTime:0.001583s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (822093,907801,462880,304309,539010,324246,516675,424596,11908,535411,1037514,292739,379438,402760,330417,942741,485219,310550,680206,706366,244682,660215,676171,425030,263260,998720,228640,373601,867605,808341,1029635,947581,1046937,349670,14362,806704,117171,674594,64623,259149,363050,646046,576341,585955,163188,872704,424147,210641,561327,528570,854366,997083,912645,942434,489787,496907,170224,61877,581893,294373) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047714 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047714 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000520s ]