SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040409 LIMIT 1 [ RunTime:0.000445s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040409 [ RunTime:0.001824s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1035869,826233,77598,426675,338569,702428,976528,70985,108478,587510,508070,820766,815457,668128,494963,38724,416911,694353,441739,51057,684524,973789,199578,444573,921076,331901,870289,851330,994945,737899,690787,133278,743083,959609,443415,770027,635986,651282,430286,157164,198212,651616,79312,311342,39916,52216,600017,61928,639312,484507,344515,657559,563069,454661,165963,57916,982229,1029779,144675,516661) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000954s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040409 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001664s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040409 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]