SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 592017 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 592017 [ RunTime:0.003064s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (838235,62427,313200,120680,94602,927646,408194,1029152,358346,346704,991653,399229,725404,325102,213900,835750,982492,473988,41819,963887,163973,479656,746973,194922,824353,393863,254412,57622,334389,132026,204981,150682,890573,1044225,604111,165808,972304,369357,626979,169518,580725,865211,725385,125574,533106,162925,458052,379718,6313,55868,875205,791590,333886,866847,929832,986889,762700,721965,598580,106565) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002612s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 592017 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000470s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 592017 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]