SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 367748 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 367748 [ RunTime:0.001477s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (551397,234525,98418,133614,651074,18311,659135,754710,530779,7576,779960,138217,3798,325605,53094,182236,768056,129206,341770,556752,887668,649557,578777,602861,51232,408601,549176,1000878,208769,503164,414127,863701,122680,617899,649089,869437,863650,889976,128437,417116,776177,835141,387568,313409,755397,742894,44592,712293,388378,795624,588694,334824,602672,904982,260657,1005639,156098,717513,297454,815737) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000922s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 367748 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 367748 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000483s ]