SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.009058s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 682706 LIMIT 1 [ RunTime:0.001898s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 682706 [ RunTime:0.002998s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (478573,819333,685100,672424,233983,695029,985576,537533,349937,268113,456628,496201,809333,440449,472444,386067,103692,804508,627198,549957,382757,273263,870941,123023,892937,256489,21507,474122,338241,876923,107563,539523,121217,4582,680297,348022,407938,480112,780739,365729,695237,103743,143741,668063,258265,189065,320084,685762,376700,912872,985054,874243,482684,229396,632390,196718,994926,588557,91021,271271) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 682706 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002716s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 682706 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002555s ]