SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001781s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 150171 LIMIT 1 [ RunTime:0.000460s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 150171 [ RunTime:0.003746s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (119937,1002939,234254,859764,298802,12900,218406,269504,1004248,1046134,267797,143309,92507,41977,606373,200213,444582,644689,113203,162401,104744,822249,675142,406627,180925,383133,825157,378111,629126,591327,176846,634715,224436,532940,655244,19912,324826,139410,1001092,435722,399525,448199,31946,338349,276955,547894,92654,1035898,1009401,974864,538219,731935,385380,25493,280306,986285,920374,47829,752254,761086) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001844s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 150171 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000629s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 150171 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]