SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416951 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416951 [ RunTime:0.001746s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (418001,773713,552098,74766,773582,50084,585920,318959,231585,940833,45564,977911,681443,305695,899954,528932,476980,586029,402696,118526,701030,353196,822081,108770,990572,355953,459371,902991,127255,988106,146826,674218,320081,812431,276924,68160,164391,384088,226275,143225,260620,710192,466971,161550,319685,423076,357176,42164,732290,600262,813741,711875,284800,622576,478449,527683,550335,483994,921471,975436) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416951 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416951 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]