SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802405 LIMIT 1 [ RunTime:0.000436s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802405 [ RunTime:0.002149s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (535267,104186,65907,663687,51007,565751,393725,661163,197932,847345,796109,128680,638888,46045,543740,454000,237273,991896,93333,208340,653248,265025,887943,741909,20423,331516,552283,484855,725509,288440,1007193,233684,841138,735934,393987,561630,590582,778857,1010876,796870,351695,345711,373589,667387,490070,473649,529791,698666,283193,82459,284016,1024167,213890,738568,940948,837230,398638,466144,645414,279188) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002634s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802405 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000637s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802405 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]