SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 267460 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 267460 [ RunTime:0.002743s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (571848,229900,451313,815530,492918,789581,391061,1025904,584755,417231,1008781,497410,75337,682584,808857,933796,233450,859172,411026,371313,310760,359769,409154,218174,25193,343193,653282,441339,606750,858907,520553,92000,560594,70356,1009140,468663,460115,601977,637423,208710,82441,896651,993894,668844,511999,1036343,627586,533615,59805,1047175,398805,431958,293822,828024,62850,979444,1040418,469802,851011,1011265) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 267460 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000660s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 267460 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]