SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 472840 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 472840 [ RunTime:0.002052s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (250393,765893,294677,827574,1045243,228511,236068,385663,25179,707565,411105,651790,335204,65163,57001,569071,1048444,745589,82267,258965,880983,1016448,458763,689104,577644,133727,982095,919670,276975,606331,684220,286079,679964,1046336,913116,763181,592947,582659,736994,111034,406563,456651,73761,414947,844154,95099,92172,706271,478565,85726,561486,820600,299168,547634,500731,727359,905970,979651,690343,319297) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 472840 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 472840 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000483s ]