SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419400 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419400 [ RunTime:0.001696s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (750897,452821,399798,500947,343687,821551,846848,296582,212318,140059,175259,251595,181072,768929,502962,950139,1036006,811054,495138,750985,377705,51262,113122,199375,603451,809374,292469,59736,694028,958624,14945,773170,532349,185705,33321,24162,114185,740284,150334,172020,714694,337471,461279,538923,10287,549974,193059,590198,841806,296719,964690,314514,162966,971558,252831,887692,578596,568092,440313,318062) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419400 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419400 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]