SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001752s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 552016 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 552016 [ RunTime:0.003112s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (828104,32522,971170,859954,521428,397056,280862,255916,253366,181897,401352,89549,194002,73549,810658,539129,354977,669701,1017823,737482,965655,406044,622617,322818,1025336,1000436,97464,390020,505000,611812,146358,958382,464961,892599,313626,358488,405638,947361,466718,1003416,118728,628818,457211,24428,133750,126279,483687,874264,300348,87386,431991,287480,998752,423207,150819,813627,615468,792426,779593,674320) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002551s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 552016 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 552016 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]