SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201026 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201026 [ RunTime:0.001661s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (995651,566368,875491,361259,57148,589300,704972,812982,636648,613858,168709,205322,205769,738481,1038220,267877,446544,393249,408309,548737,41319,751379,75663,839467,111004,875868,454234,224620,668852,883603,965719,443617,80893,911029,925227,9590,815127,879956,192954,1045700,639696,767573,441264,238368,1014195,696090,38947,662313,402384,255767,989978,118223,637413,987001,86147,933098,61770,640844,929545,110697) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201026 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201026 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]