SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 305185 LIMIT 1 [ RunTime:0.002896s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 305185 [ RunTime:0.003629s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (533141,976474,1028839,63196,246641,769863,580953,690553,753613,797022,306788,145121,721525,513979,254213,817480,1032317,1012784,291759,686682,552586,844847,915723,739625,188670,176688,952290,746628,123288,192208,769828,880171,201841,805643,542231,106405,794317,274436,756464,175752,286206,215910,329965,369291,530575,435859,246811,1037153,777906,719185,114009,192594,328070,134928,372309,306291,629056,87585,602437,374739) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 305185 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 305185 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]