SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522207 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522207 [ RunTime:0.002581s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (126616,211439,782569,980782,210453,480652,789867,28405,989290,215649,1047202,108068,993399,535455,42176,362026,576930,10544,740219,819154,331387,813724,273254,64288,646342,303970,700265,216716,836464,210314,499099,138412,188256,748690,12027,254501,307782,488651,326710,10780,608179,601528,65942,182651,466649,1048489,319431,1697,841986,887028,232327,946945,908014,752085,640665,875062,4034,1022394,985504,247396) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001704s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522207 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522207 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]