SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480714 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480714 [ RunTime:0.001935s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (37211,809144,302402,708037,778167,422511,673021,47110,659081,837539,122932,870961,906868,851129,90124,1017493,314295,201269,609432,1024852,12670,489900,1031764,116759,284300,267176,153367,437803,732644,342086,161274,500607,977027,20417,990194,198912,138602,847807,703449,961979,774049,615605,259328,656027,887670,371352,202811,328895,1002985,836109,664900,196038,555259,208161,727945,377509,976770,563423,587314,650689) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480714 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000564s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480714 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000464s ]