SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047780 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047780 [ RunTime:0.002454s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (30399,776650,242846,947433,900301,305900,1001255,322285,788979,797263,359860,623563,563429,525252,88451,144978,165573,8688,464289,153402,646184,317895,91697,60001,80141,374772,224554,584223,508251,443334,362584,909069,420309,157685,836937,34878,148493,463981,627698,441183,1030317,942131,898055,1005734,887770,745451,83061,396049,547389,518328,121188,758742,837329,707037,583837,659877,671779,463770,852535,755012) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047780 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047780 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]