SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029619 LIMIT 1 [ RunTime:0.009355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029619 [ RunTime:0.002164s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (553049,681965,854916,1047545,248092,354065,306110,45969,839867,78233,394209,752760,896401,185722,358985,359350,616841,571916,918740,325484,356031,404266,795288,225000,296225,791985,743772,96037,596796,84865,969959,556803,229845,26552,200084,1030165,277460,1048697,53587,104399,54046,494476,835039,406009,214099,686429,837374,85750,706962,946458,1012363,1017343,91519,698298,689941,519705,118986,579063,805949,586385) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029619 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029619 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000635s ]