SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475132 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475132 [ RunTime:0.001683s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (427459,1022293,1033979,148607,71006,420874,306994,1024920,287496,517303,59484,147946,161451,542594,777783,950117,190980,653913,449755,428425,192744,896827,1048389,371122,585541,192273,424229,729413,22971,200331,730062,109308,938551,385953,396612,3685,236310,61537,272840,100202,176369,338296,772109,889483,686103,73545,72325,264541,503772,830378,903216,1042198,807400,356912,939301,867361,605431,452185,368702,32864) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475132 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475132 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001218s ]