SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514060 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514060 [ RunTime:0.001819s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (137662,767046,935203,1006007,890299,754298,530888,10847,278023,723705,161219,48159,1014438,666369,881068,3502,476246,203481,819894,212738,998106,300228,650557,1017202,390871,1033258,43374,1020725,990845,795762,686633,731119,109951,741523,971544,760786,865344,390984,956658,248474,401505,466578,993143,688505,556226,110155,946888,938241,595315,466374,698605,542814,493406,52623,951514,624502,1033991,979285,805455,494732) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514060 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514060 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000447s ]