SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455765 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455765 [ RunTime:0.002025s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (254676,984543,884306,77337,1029150,664954,619850,924689,613376,694470,769524,72273,134702,122409,614788,507646,43815,680652,393899,442645,666300,593708,814317,33140,545153,327335,267078,973902,250290,175349,326780,166049,1020813,915635,705167,260825,73326,502570,552540,634435,347476,995704,529676,935230,690262,502472,569223,608414,103891,727528,634613,678270,105394,483069,243827,158876,570743,347424,683634,935540) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455765 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455765 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000463s ]