SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542903 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542903 [ RunTime:0.001754s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (644247,849314,82742,687989,130686,2618,915075,705098,157306,1019991,522683,665194,481628,535021,211552,388906,860550,866532,893087,723863,148673,41610,225479,596991,726817,610424,529200,103948,867331,74147,1036681,767672,9626,1210,524894,641868,1042127,717492,314275,839806,347239,501993,651271,86713,580504,120189,609140,185790,348178,626915,772853,131893,501309,304863,202855,363580,160870,451634,384677,683399) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542903 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000552s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542903 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]