SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001410s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505902 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505902 [ RunTime:0.001562s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (551373,703441,701024,1040206,208130,787393,874419,219953,521391,889015,173142,923144,272122,454188,516278,325193,666364,649102,981974,839858,748672,550483,879169,332265,340954,283511,56914,12358,867782,513578,831034,1039863,348347,15925,972530,844844,224966,338100,102070,282105,736079,729730,349714,576009,591767,915521,107527,188293,917187,415781,853946,236724,637032,571705,421235,1003899,998659,952631,920783,73231) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003202s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505902 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505902 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000899s ]