SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 876210 LIMIT 1 [ RunTime:0.001794s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 876210 [ RunTime:0.001643s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (609774,1018601,124645,253496,120110,141311,1025293,974792,617191,336486,1004975,414346,1046764,652893,314647,453623,289970,297723,200980,508289,307734,648909,12831,166193,314915,733534,39124,191109,377321,786121,585040,792893,161353,77209,204107,555508,282899,645362,83997,419208,79323,625114,516513,406151,587875,538910,917042,165928,222985,138718,4860,572582,857957,1003715,101809,722323,447974,721524,335202,135816) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 876210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 876210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000665s ]