SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001394s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 479031 LIMIT 1 [ RunTime:0.000575s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 479031 [ RunTime:0.001669s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (993585,647884,719954,515594,610712,370638,885148,151477,341217,1026904,747139,262356,992207,629305,336465,135342,154146,988581,584807,513505,587449,225638,153772,221014,131735,472412,663697,1044740,646920,428230,30624,559968,208220,482201,791688,993431,737643,313508,986381,236164,914714,48400,628135,1009351,783280,452099,101572,813168,415267,277169,161363,1008779,283982,406715,674024,961388,716530,972750,960898,1024461) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000964s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 479031 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 479031 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]