SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 518085 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 518085 [ RunTime:0.001597s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (406281,958187,506612,768699,319649,52801,57629,405743,755855,532169,471344,312488,766479,641663,8475,984553,933939,1002591,903600,557215,629618,468710,735655,892750,44753,216121,198247,820539,12169,631984,233279,728120,584759,541745,868117,808332,822462,553993,807180,175125,45182,886831,201517,821255,322842,215378,786405,864041,52871,594514,116807,890544,943620,818126,753359,528318,882364,207180,736924,391295) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 518085 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 518085 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000444s ]