SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 554214 LIMIT 1 [ RunTime:0.000451s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 554214 [ RunTime:0.001633s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (976651,833976,198904,674315,778674,41069,330589,916868,396163,704588,68972,108143,332825,716746,285054,677759,629717,117931,212658,976960,694188,784104,407075,256183,331795,479270,802818,545150,469528,545860,96431,94935,169713,341035,75807,140460,924247,838649,285320,469773,84748,924155,178988,265859,451750,726896,411332,522979,611598,795476,610081,754623,954066,180370,105400,248069,65397,101938,763507,91972) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001558s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 554214 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 554214 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000660s ]