SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002811s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 312091 LIMIT 1 [ RunTime:0.002404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 312091 [ RunTime:0.006907s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1034894,1023584,582350,343891,985857,834599,804600,706674,645062,736377,980033,974846,329894,1038592,380635,562968,237327,811803,2124,295108,897581,275955,551198,383467,839841,921567,732214,447039,464182,289753,956820,772320,273341,229810,992467,909750,895872,532590,114031,998603,645188,103077,942113,724381,636943,364380,498562,804509,867902,43754,505991,51604,110519,146406,31909,176355,427815,356176,271413,455749) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003679s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 312091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000482s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 312091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002372s ]