SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536541 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536541 [ RunTime:0.004433s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (149328,854685,599976,572944,1043408,402921,502276,995398,348977,86129,642683,873968,295861,879303,182035,1012857,577813,788982,24843,1045858,334365,414374,142208,45310,839812,1005912,70214,632330,112891,716516,40781,331032,421370,694442,882599,297992,559602,913862,281055,697969,560347,711166,590957,1009790,929632,132974,281258,445166,668225,623846,209797,235573,1042718,80976,238666,15175,552253,989636,818985,758191) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536541 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536541 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001289s ]