SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34101 LIMIT 1 [ RunTime:0.000617s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34101 [ RunTime:0.001858s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (874804,379078,902059,736040,819150,1013439,10189,210463,200855,986519,635435,92988,861144,957284,147726,234841,428743,805505,776387,973005,841552,1002671,215754,298068,630268,191740,779796,523400,419098,14050,133363,988030,262842,919961,789978,65941,1042493,12247,634052,374470,417194,170093,361714,920561,286773,489183,869577,879306,281277,917978,484483,930480,111320,18179,117130,1039443,472629,479649,985436,255728) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001567s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]