SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001391s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4834 LIMIT 1 [ RunTime:0.000802s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4834 [ RunTime:0.003259s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (451781,179438,936871,1010213,233645,866194,43099,841927,390373,911871,707207,852197,725129,935887,682622,255408,676566,175288,1042837,688761,637359,546342,307732,367412,259568,140183,654525,665805,698903,867111,273985,272844,855520,146493,981382,340976,463261,336929,583883,95720,5309,802844,838486,646802,1805,718163,663906,472934,963468,295773,108925,609191,463865,355909,325311,744044,23380,444763,184500,473482) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4834 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4834 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000641s ]