SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002386s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545105 LIMIT 1 [ RunTime:0.000483s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545105 [ RunTime:0.003690s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (162763,471942,223375,161913,158264,355470,47144,142562,165638,692052,298961,31325,379135,65129,1028710,544839,779920,484079,579439,858731,699629,336122,926001,959643,40940,142638,708610,11838,384381,552558,373641,93183,755434,205518,584879,844178,372127,317723,646694,397104,464235,297791,700662,832816,610216,61411,197764,97773,253534,942728,357242,763344,728945,926179,420331,795413,1006125,857447,1006379,943829) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005113s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545105 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545105 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001201s ]