SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046842 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046842 [ RunTime:0.001913s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (288296,503700,1003363,874876,1559,617188,177864,412174,659543,63445,568320,502060,132514,450078,988704,701950,398965,430612,1032029,667703,122733,86882,471535,569665,934489,105876,266612,544905,268797,209887,394522,612391,529946,625738,315951,615051,463891,838994,185323,47534,277268,536039,340936,967677,31909,84293,65480,681416,675745,929762,707213,281163,23003,450977,657804,32432,537177,737552,566295,888955) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000972s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046842 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046842 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000767s ]